Executive Summary 23

********************************************************************

Executive Summary
********************************************************************

This Executive Summary section is a two part section.

GIF
Troubles that occurred on the Project

GIF - Your gif will take up the whole slide

Dashboard

The gif should include you making random selections in your dashboard
Click on at least one entry in every dimension
If your dashboard has drill down or drill through features, ensure you show that
If your dashboard has a map, make sure you click on that
Give a second or two between clicks so people can see how the data reacts
Include the calculation

ETL or Process

Create a Power Point presentation and create the GIF while on full screen
The GIF will consist of you clicking through your Power Point Presentation
At this point you've already broken down your project step by step in the stress test
You will break your presentation down in a similar fashion. Each step will have a...

1. Black Screen with Big White Font

2. No more than 6 words per step

3. Step will show up in the same place on every slide

3. Colaberry Logo

4. Each Slide will show for 2 seconds

5. In between each step will be the screenshots of the work done in that step. This includes screenshots from the Database, ETL package, code etc...

a. If you only have one slide for the step, you will show it for 2 seconds

b. If you have more than one slide for the step, you show each slide for one second each

6. The end result is a 20-30 second (Under 5MB) fast pace moving GIF that summaries everything you've completed in the project. This will represent the visual needed to showcase the great work you put in on the project.

Troubles that occurred on the Project

This section will be in two parts - Text & Pictures
If you followed the Project Checklist, you have already documented problems that occurred on your project
In the text portion, you will give 2-3 problems that occurred in text.
Each step should be numbered
In the Pictures section you will find a picture that represents each problem.
In the pictures, you could take screenshots of actual parts of your project or you could show pictures that relate to your problem. Remember to always capture the hearts of the audience.
Numbers must be numbered with same font / size / text / color to keep consistency
There should be no titles except before the numbered steps

Dashboard Example:

Problems that occurred During Project

1. Start working on this data set, the data was subset of the data, so the solutions was that the data set got fixed by the company.
2. having right company’s KPI by analyzing the data. finally, one of the company’s KPI’s was year over year, but in this data set there is only 20 months, so I cannot use year over. And then, instead of using the year over year calculation, changed to month over month.

Troubles that occurred during the project
The data coming from source had to be cleaned and remove special characters such as quotations, hyphens , dashes, etc.
Finding the Calculation for Decade Over Decade. Researched different DAX formulas for the calculation.

DW example:

ISSUES THAT OCCURRED DURING THE PROJECT

1. Unpivoting & Pivoting the Source Excel files

2. Converting the Quarter from 'NQYYYY' to Date format 'MM/DD/YYYY'

Instructions:

Assign this task to yourself.
Once you have read through this task and you fully understand it, write a small paragraph with screenshots and notes of what you learned. Then add it as a comment on this task.
Everyday you work on this task, you will add a minimal of a comment and a screenshot. Gifs are good as well.
Note: You as well as other people will be reading through your project notes. Make sure you talk about your thoughts at the moment so you and others can relive the experience.
Upon completion, close the task and navigate back to your Colaberry Project Dashboard.